CREATE TABLE [dbo].[JY_XJH]
(
[JY_XJH_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_XJH_Unit_ID] [int] NULL,
[JY_XJH_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Time] [datetime] NULL,
[JY_XJH_Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Linkman_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Hold_Number] [int] NULL,
[JY_XJH_LastYear_Number] [int] NULL,
[JY_XJH_LastYear_Pen_Num] [int] NULL,
[JY_XJH_LastYear_View_Num] [int] NULL,
[JY_XJH_LastYear_Get_Num] [int] NULL,
[JY_XJH_ThisYear_Num] [int] NULL,
[JY_XJH_GetJob_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Click_Num] [int] NULL,
[JY_XJH_Add_Time] [datetime] NULL,
[JY_XJH_Add_User] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Download] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_XJH_Level] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[JY_XJH] ADD 
CONSTRAINT [PK_JY_XJH] PRIMARY KEY CLUSTERED  ([JY_XJH_ID]) ON [PRIMARY]
GO
